<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
/*********************************************************************************
 * SugarCRM Community Edition is a customer relationship management program developed by
 * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
 * 
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU Affero General Public License version 3 as published by the
 * Free Software Foundation with the addition of the following permission added
 * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
 * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
 * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
 * 
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
 * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
 * details.
 * 
 * You should have received a copy of the GNU Affero General Public License along with
 * this program; if not, see http://www.gnu.org/licenses or write to the Free
 * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
 * 02110-1301 USA.
 * 
 * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
 * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
 * 
 * The interactive user interfaces in modified source and object code versions
 * of this program must display Appropriate Legal Notices, as required under
 * Section 5 of the GNU Affero General Public License version 3.
 * 
 * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
 * these Appropriate Legal Notices must retain the display of the "Powered by
 * SugarCRM" logo. If the display of the logo is not reasonably feasible for
 * technical reasons, the Appropriate Legal Notices must display the words
 * "Powered by SugarCRM".
 ********************************************************************************/


/**
 * Set up an array of Jobs with the appropriate metadata
 * 'jobName' => array (
 * 		'X' => 'name',
 * )
 * 'X' should be an increment of 1
 * 'name' should be the EXACT name of your function
 *
 * Your function should not be passed any parameters
 * Always  return a Boolean. If it does not the Job will not terminate itself
 * after completion, and the webserver will be forced to time-out that Job instance.
 * DO NOT USE sugar_cleanup(); in your function flow or includes.  this will
 * break Schedulers.  That function is called at the foot of cron.php
 */

/**
 * This array provides the Schedulers admin interface with values for its "Job"
 * dropdown menu.
 */
$mod_strings['LBL_MIGRATEUSERTOBENEFICIARIE']="Migrate User To Beneficiarie";
 
$job_strings[]="migrateUserToBeneficiarie";

function migrateUserToBeneficiarie()
{
	global $db;
	$query = "select id,bank_name,branch_name,bank_account_number,branch_code,iban_number,swift_code,branch_address,branch_city,branch_state,branch_postalcode,banking_country,banking_currency,intermediary_bank_name,intermediary_bank_account_number,intermediary_bank_account_name,intermediary_bank_swift_code,intermediary_bank_info_note FROM users";
	$result=$db->query($query);
	while($row = $db->fetchByAssoc($result)) {
         $user_information[] = $row;
        }
	foreach($user_information as $k=>$information)
	{
		$beneficarie = new edanz_Beneficiaries();
		$beneficarie->bank_name = $information['bank_name'];
		$beneficarie->branch_name = $information['branch_name'];
		$beneficarie->bank_account_number = $information['bank_account_number'];
		$beneficarie->branch_code = $information['branch_code'];
		$beneficarie->iban_number = $information['iban_number'];
		$beneficarie->swift_code = $information['swift_code'];
		$beneficarie->branch_address = $information['branch_address'];
		$beneficarie->branch_city = $information['branch_city'];
		$beneficarie->branch_state = $information['branch_state'];
		$beneficarie->branch_postalcode = $information['branch_postalcode'];
		$beneficarie->banking_country = $information['banking_country'];
		$beneficarie->banking_currency = $information['banking_currency'];
		$beneficarie->intermediary_bank_name = $information['intermediary_bank_name'];
		$beneficarie->intermediary_bank_account_number = $information['intermediary_bank_account_number'];
		$beneficarie->intermediary_bank_account_name = $information['intermediary_bank_account_name'];
		$beneficarie->intermediary_bank_swift_code = $information['intermediary_bank_swift_code'];
		$beneficarie->intermediary_bank_info_note = $information['intermediary_bank_info_note'];
		$beneficarie->save();
		
		$edithor_id = $information['id'];
		$beneficarie_id = $beneficarie->id;
		
		$query_insert="INSERT INTO editors_beneficiaries VALUES (UUID(), '$beneficarie_id', '$edithor_id', NOW(), 0, 0)";   
		$db->query($query_insert);
	}
	return true;
}

?>
